package com.teach.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.teach.dto.PhotoPicPicClassDTO;

public interface PhotoPicPicClassMapper {

		@Select("SELECT	photo_pic_class.photo_pic_class_name "
			+ "FROM photo_pic	INNER JOIN photo_pic_class "
			+ "ON photo_pic_class.photo_pic_class_id = photo_pic.photo_pic_class_id")
		List<PhotoPicPicClassDTO> selectName();
		
		@Select("SELECT	* FROM photo_pic INNER JOIN photo_pic_class ON"
			+ " photo_pic.photo_pic_class_id = photo_pic_class.photo_pic_class_id "
			+ "WHERE photo_pic_class.photo_pic_class_name=#{photoPicClassName}")
		List<PhotoPicPicClassDTO> selectType(@Param("photoPicClassName")String photoPicClassName);
}
